package com.yulan.bankback.mapper.admin;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.yulan.bankback.entity.model.admin.BlackUserPromote;
import com.yulan.bankback.entity.model.admin.KindUser;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.List;

@Component
public interface KindUserMapper extends BaseMapper<KindUser> {

    @Select("select time, count from black_user_promote " +
            " where time > NOW() - INTERVAL ${interval} order by time")
    List<BlackUserPromote> getIntervalPromote(String interval);
}
